Film_Locations_in_San_Francisco

8 rows where Release Year = 34

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
241	241	Can't Stop the Music 45	1980 34	101 Henry Adams Place		EMI Films 40	Associated Film Distribution (AFD) 32	Nancy Walker 43	Allan Carr 42	Ray Simpson 276	David Hodo 38	Felipe Rose 460
637	637	Heart Beat 117	1980 34	San Francisco Art Institute (800 Chestnut Street)		Orion Pictures Corporation 80	Orion Pictures Corporation 56	John Byrum 109	John Byrum 108	Nick Nolte 19	Sissy Spacek 93	John Heard 451
638	638	Heart Beat 117	1980 34	Washington Square Bar & Grill (1707 Powell)		Orion Pictures Corporation 80	Orion Pictures Corporation 56	John Byrum 109	John Byrum 108	Nick Nolte 19	Sissy Spacek 93	John Heard 451
639	639	Heart Beat 117	1980 34	City Lights Bookstore (261 Columbus)	One of the country's earliest bookstores, City Lights was founded by, and still owned by beat poet Lawrence Ferlinghetti. The bookstore was often frequented by Beat writers like Allen Ginsberg and Jack Kerouac.	Orion Pictures Corporation 80	Orion Pictures Corporation 56	John Byrum 109	John Byrum 108	Nick Nolte 19	Sissy Spacek 93	John Heard 451
992	992	Nine to Five 179	1980 34	Albert S. Samuels Clock (856 Market Street between Powell and Stockton)		Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Colin Higgins 90	Colin Higgins 91	Jane Fonda 349	Lily Tomlin 136	Dolly Parton 504
1158	1158	Serial 212	1980 34	Ferry Building	Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.	Paramount Pictures 4	Paramount Pictures 3	Bill Persky 175	Rich Eustis 184	Martin Mull 375	Tuesday Weld 162
1332	1332	The Competition 248	1980 34	Pier 39		Columbia Pictures Corporation 5	American Broadcasting Company (ABC) 51	Joel Oliansky 204	Joel Oliansky 215	Richard Dreyfuss 252	Amy Irving 190	Lee Remick 57
1333	1333	The Competition 248	1980 34	California Academy of Sciences (Golden Gate Park)	Founded in 1853, 3 years after California joined the United States, the Academy was originally named the California Academy of Natural Sciences and was the first institution of its kind in the United States.	Columbia Pictures Corporation 5	American Broadcasting Company (ABC) 51	Joel Oliansky 204	Joel Oliansky 215	Richard Dreyfuss 252	Amy Irving 190	Lee Remick 57

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");